.. _`Select columns in Table with Regex`:

.. _`org.sysess.sympathy.data.table.selecttablecolumnsregex`:

Select columns in Table with Regex
``````````````````````````````````

.. image:: select_table_columns.svg
   :width: 48


Select all columns whose names match a regex.




Documentation
:::::::::::::

Select all columns whose names match a regular expressions (regex). For
more information about how to write regex, see :ref:`appendix_regex`.


Definition
::::::::::


Input ports
...........

    **port1**  table
        Input Table


Output ports
............

    **port2**  table
        Table with a subset of the incoming columns




Configuration
.............

    **Remove matching columns** (complement)
        When enabled, matching columns will be removed. When disabled, non-matching columns will be removed.
    **Match at column name start** (full_match)
        When enabled, only matching pattern at the startof column name will be found.When disabled, matching pattern in any part ofcolumn name will be found.
    **Search** (regex)
        Regex search pattern for matching column names. Learn more about Regular expression syntax in the documentation appendix.





Related nodes
.............

* :ref:`org.sysess.sympathy.data.table.selecttablecolumns`

* :ref:`org.sysess.sympathy.data.table.selecttablecolumnstype`

* :ref:`org.sysess.sympathy.data.table.selecttablecolumnsfromtable`




Examples
........

* :download:`SelectColumns.syx </Examples/Sympathy/Data Processing/Select/SelectColumns.syx>`




Implementation
..............

.. automodule:: node_select_table_columns
    :noindex:

.. class:: SelectTableColumnsRegex
    :noindex: